package com.bingbing.back.mapper;

import com.bingbing.back.dto.SchoolAdmScoreDto;
import com.bingbing.back.po.SchoolAdmScore;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface SchoolAdmScoreMapper {

    // 根据年份直接返回该年份下的所有录取批次
    List<String> searchAdmScoreBatchByYear(int admYear);

    // 根据学校id可附带年份查询分数线，位次，省控线
    List<SchoolAdmScoreDto> searchAdmScore(SchoolAdmScore schoolAdmScore);

    // 得到数据库中最新的年份和分数
    SchoolAdmScore getLatestYear(int schoolId);

    // 得到分数相近的学校编号和分数
    List<SchoolAdmScore> getCloseScoreSchool(int schoolId, int admYear, int schoolLoScore);
}
